Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	6672
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.1 MiB
Average record size in memory	168.0 B

Variable types

Numeric	20

Alerts

`id` has unique values	Unique
`payments` has unique values	Unique
`min_pay` has unique values	Unique
`one_purchases` has 2149 (32.2%) zeros	Zeros
`install_purchases` has 1784 (26.7%) zeros	Zeros
`cash_adv` has 4430 (66.4%) zeros	Zeros
`one_purchases_freq` has 2149 (32.2%) zeros	Zeros
`purchases_install_freq` has 1784 (26.7%) zeros	Zeros
`cash_adv_freq` has 4430 (66.4%) zeros	Zeros
`cash_adv_TRX` has 4430 (66.4%) zeros	Zeros
`prc_full_pay` has 4022 (60.3%) zeros	Zeros

Reproduction

Analysis started	2023-01-17 17:17:04.887373
Analysis finished	2023-01-17 17:18:11.852311
Duration	1 minute and 6.96 seconds
Software version	pandas-profiling vv3.6.2
Download configuration	config.json

id
Real number (ℝ)

Distinct	6672
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14573.142

Minimum	10001
Maximum	19190
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	10001
5-th percentile	10469.55
Q1	12260.5
median	14555
Q3	16903.5
95-th percentile	18711.45
Maximum	19190
Range	9189
Interquartile range (IQR)	4643

Descriptive statistics

Standard deviation	2656.2514
Coefficient of variation (CV)	0.18227033
Kurtosis	-1.2141426
Mean	14573.142
Median Absolute Deviation (MAD)	2327.5
Skewness	0.013698577
Sum	97232003
Variance	7055671.7
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10001	1	< 0.1%
16031	1	< 0.1%
16132	1	< 0.1%
16131	1	< 0.1%
16130	1	< 0.1%
16129	1	< 0.1%
16128	1	< 0.1%
16127	1	< 0.1%
16126	1	< 0.1%
16125	1	< 0.1%
Other values (6662)	6662	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10001	1	< 0.1%
10003	1	< 0.1%
10005	1	< 0.1%
10006	1	< 0.1%
10007	1	< 0.1%
10008	1	< 0.1%
10009	1	< 0.1%
10010	1	< 0.1%
10011	1	< 0.1%
10012	1	< 0.1%

Value	Count	Frequency (%)
19190	1	< 0.1%
19188	1	< 0.1%
19186	1	< 0.1%
19184	1	< 0.1%
19183	1	< 0.1%
19182	1	< 0.1%
19181	1	< 0.1%
19180	1	< 0.1%
19177	1	< 0.1%
19175	1	< 0.1%

balance
Real number (ℝ)

Distinct	6667
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1421.4681

Minimum	0
Maximum	19043.139
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	11.306426
Q1	95.633532
median	653.8763
Q3	1819.0748
95-th percentile	5703.3562
Maximum	19043.139
Range	19043.139
Interquartile range (IQR)	1723.4412

Descriptive statistics

Standard deviation	2052.7901
Coefficient of variation (CV)	1.4441338
Kurtosis	9.6320128
Mean	1421.4681
Median Absolute Deviation (MAD)	610.67437
Skewness	2.6714897
Sum	9484035.3
Variance	4213947.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6	0.1%
40.900749	1	< 0.1%
1253.188317	1	< 0.1%
1275.142146	1	< 0.1%
53.583548	1	< 0.1%
18.105265	1	< 0.1%
954.431507	1	< 0.1%
252.717781	1	< 0.1%
1213.551338	1	< 0.1%
1636.518315	1	< 0.1%
Other values (6657)	6657	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.1%
0.000199	1	< 0.1%
0.001289	1	< 0.1%
0.004816	1	< 0.1%
0.009684	1	< 0.1%
0.064811	1	< 0.1%
0.065402	1	< 0.1%
0.25571	1	< 0.1%
0.327199	1	< 0.1%
0.41367	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%
15532.33972	1	< 0.1%
15258.2259	1	< 0.1%
15244.74865	1	< 0.1%
15155.53286	1	< 0.1%
14411.95798	1	< 0.1%

balance_freq
Real number (ℝ)

Distinct	40
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.89250335

Minimum	0
Maximum	1
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.363636
Q1	0.909091
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.090909

Descriptive statistics

Standard deviation	0.21033824
Coefficient of variation (CV)	0.23567221
Kurtosis	3.202882
Mean	0.89250335
Median Absolute Deviation (MAD)	0
Skewness	-2.0476324
Sum	5954.7824
Variance	0.044242173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
1	4711	70.6%
0.909091	324	4.9%
0.818182	228	3.4%
0.545455	182	2.7%
0.727273	180	2.7%
0.636364	171	2.6%
0.454545	136	2.0%
0.363636	131	2.0%
0.272727	118	1.8%
0.181818	97	1.5%
Other values (30)	394	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.1%
0.090909	21	0.3%
0.142857	1	< 0.1%
0.166667	1	< 0.1%
0.181818	97	1.5%
0.2	4	0.1%
0.222222	2	< 0.1%
0.25	4	0.1%
0.272727	118	1.8%
0.285714	4	0.1%

Value	Count	Frequency (%)
1	4711	70.6%
0.909091	324	4.9%
0.9	34	0.5%
0.888889	38	0.6%
0.875	36	0.5%
0.857143	31	0.5%
0.833333	40	0.6%
0.818182	228	3.4%
0.8	17	0.3%
0.777778	14	0.2%

purchases
Real number (ℝ)

Distinct	6015
Distinct (%)	90.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1327.2852

Minimum	0
Maximum	49039.57
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	59
Q1	250.69
median	615.18
Q3	1499.955
95-th percentile	4627.008
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1249.265

Descriptive statistics

Standard deviation	2382.9188
Coefficient of variation (CV)	1.7953329
Kurtosis	92.001509
Mean	1327.2852
Median Absolute Deviation (MAD)	458.735
Skewness	7.4850383
Sum	8855646.9
Variance	5678302.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45.65	25	0.4%
150	15	0.2%
60	13	0.2%
200	12	0.2%
100	12	0.2%
450	12	0.2%
600	10	0.1%
70	10	0.1%
1000	9	0.1%
120	9	0.1%
Other values (6005)	6545	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
0.01	3	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
1	2	< 0.1%
2	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
4.99	1	< 0.1%
6.9	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%
32539.78	1	< 0.1%
31299.35	1	< 0.1%
27957.68	1	< 0.1%
27790.42	1	< 0.1%
26784.62	1	< 0.1%

one_purchases
Real number (ℝ)

Distinct	3922
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	782.96295

Minimum	0
Maximum	40761.25
Zeros	2149
Zeros (%)	32.2%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	202.745
Q3	869.085
95-th percentile	3216.3905
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	869.085

Descriptive statistics

Standard deviation	1879.5377
Coefficient of variation (CV)	2.4005449
Kurtosis	129.72953
Mean	782.96295
Median Absolute Deviation (MAD)	202.745
Skewness	8.9804725
Sum	5223928.8
Variance	3532662
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2149	32.2%
45.65	43	0.6%
50	16	0.2%
200	15	0.2%
70	12	0.2%
150	12	0.2%
1000	12	0.2%
100	12	0.2%
250	11	0.2%
60	10	0.1%
Other values (3912)	4380	65.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2149	32.2%
0.01	6	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
1	4	0.1%
1.4	1	< 0.1%
2	1	< 0.1%
4.99	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%
26514.32	1	< 0.1%
25122.77	1	< 0.1%
24543.52	1	< 0.1%
23032.97	1	< 0.1%
22257.39	1	< 0.1%

install_purchases
Real number (ℝ)

Distinct	4340
Distinct (%)	65.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	544.7149

Minimum	0
Maximum	22500
Zeros	1784
Zeros (%)	26.7%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	240.5
Q3	645.19
95-th percentile	2020.269
Maximum	22500
Range	22500
Interquartile range (IQR)	645.19

Descriptive statistics

Standard deviation	1010.72
Coefficient of variation (CV)	1.8555028
Kurtosis	78.998699
Mean	544.7149
Median Absolute Deviation (MAD)	240.5
Skewness	6.6334604
Sum	3634337.8
Variance	1021555
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1784	26.7%
100	14	0.2%
200	13	0.2%
125	11	0.2%
150	11	0.2%
300	10	0.1%
75	9	0.1%
450	8	0.1%
500	8	0.1%
270	7	0.1%
Other values (4330)	4797	71.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1784	26.7%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%
7.26	1	< 0.1%
7.67	1	< 0.1%
9.58	1	< 0.1%
9.65	1	< 0.1%
9.68	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%
12560.85	1	< 0.1%
12541	1	< 0.1%
12375	1	< 0.1%
12235.05	1	< 0.1%
12128.94	1	< 0.1%

cash_adv
Real number (ℝ)

Distinct	2243
Distinct (%)	33.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	694.99841

Minimum	0
Maximum	47137.212
Zeros	4430
Zeros (%)	66.4%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	420.13572
95-th percentile	3955.9925
Maximum	47137.212
Range	47137.212
Interquartile range (IQR)	420.13572

Descriptive statistics

Standard deviation	1895.172
Coefficient of variation (CV)	2.7268724
Kurtosis	90.947207
Mean	694.99841
Median Absolute Deviation (MAD)	0
Skewness	6.8256608
Sum	4637029.4
Variance	3591676.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4430	66.4%
4327.398235	1	< 0.1%
2183.782456	1	< 0.1%
1748.234165	1	< 0.1%
1719.993551	1	< 0.1%
708.865975	1	< 0.1%
723.138529	1	< 0.1%
5160.785017	1	< 0.1%
1578.03608	1	< 0.1%
729.174169	1	< 0.1%
Other values (2233)	2233	33.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4430	66.4%
14.222216	1	< 0.1%
18.126683	1	< 0.1%
18.204577	1	< 0.1%
18.280043	1	< 0.1%
18.427395	1	< 0.1%
18.531069	1	< 0.1%
18.561424	1	< 0.1%
18.616675	1	< 0.1%
18.638559	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
20712.67008	1	< 0.1%
20277.33112	1	< 0.1%
19862.87844	1	< 0.1%
19513.47483	1	< 0.1%
18857.05847	1	< 0.1%
17661.49486	1	< 0.1%

purchases_freq
Real number (ℝ)

Distinct	47
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.64195484

Minimum	0
Maximum	1
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.083333
Q1	0.333333
median	0.727273
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.666667

Descriptive statistics

Standard deviation	0.33870784
Coefficient of variation (CV)	0.52761942
Kurtosis	-1.3775833
Mean	0.64195484
Median Absolute Deviation (MAD)	0.272727
Skewness	-0.37771823
Sum	4283.1227
Variance	0.114723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	2126	31.9%
0.083333	622	9.3%
0.916667	391	5.9%
0.5	390	5.8%
0.166667	367	5.5%
0.833333	367	5.5%
0.333333	349	5.2%
0.25	328	4.9%
0.583333	309	4.6%
0.666667	306	4.6%
Other values (37)	1117	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
0.083333	622	9.3%
0.090909	41	0.6%
0.1	23	0.3%
0.111111	16	0.2%
0.125	25	0.4%
0.142857	22	0.3%
0.166667	367	5.5%
0.181818	15	0.2%
0.2	17	0.3%

Value	Count	Frequency (%)
1	2126	31.9%
0.916667	391	5.9%
0.909091	28	0.4%
0.9	23	0.3%
0.888889	18	0.3%
0.875	26	0.4%
0.857143	23	0.3%
0.833333	367	5.5%
0.818182	20	0.3%
0.8	9	0.1%

one_purchases_freq
Real number (ℝ)

Distinct	47
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.26652097

Minimum	0
Maximum	1
Zeros	2149
Zeros (%)	32.2%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.125
Q3	0.416667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.416667

Descriptive statistics

Standard deviation	0.3168305
Coefficient of variation (CV)	1.1887639
Kurtosis	0.069147237
Mean	0.26652097
Median Absolute Deviation (MAD)	0.125
Skewness	1.1537256
Sum	1778.2279
Variance	0.10038156
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	2149	32.2%
0.083333	1057	15.8%
0.166667	576	8.6%
1	469	7.0%
0.25	408	6.1%
0.333333	346	5.2%
0.416667	243	3.6%
0.5	232	3.5%
0.583333	197	3.0%
0.666667	167	2.5%
Other values (37)	828	12.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2149	32.2%
0.083333	1057	15.8%
0.090909	54	0.8%
0.1	36	0.5%
0.111111	24	0.4%
0.125	35	0.5%
0.142857	33	0.5%
0.166667	576	8.6%
0.181818	33	0.5%
0.2	26	0.4%

Value	Count	Frequency (%)
1	469	7.0%
0.916667	151	2.3%
0.909091	4	0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%
0.875	6	0.1%
0.857143	1	< 0.1%
0.833333	115	1.7%
0.818182	10	0.1%
0.8	4	0.1%

purchases_install_freq
Real number (ℝ)

Distinct	47
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.47732552

Minimum	0
Maximum	1
Zeros	1784
Zeros (%)	26.7%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.454545
Q3	0.9
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.9

Descriptive statistics

Standard deviation	0.39158725
Coefficient of variation (CV)	0.82037778
Kurtosis	-1.575259
Mean	0.47732552
Median Absolute Deviation (MAD)	0.454545
Skewness	0.056451038
Sum	3184.7158
Variance	0.15334057
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	1784	26.7%
1	1297	19.4%
0.416667	381	5.7%
0.916667	340	5.1%
0.833333	304	4.6%
0.5	303	4.5%
0.166667	296	4.4%
0.666667	290	4.3%
0.75	284	4.3%
0.083333	248	3.7%
Other values (37)	1145	17.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1784	26.7%
0.083333	248	3.7%
0.090909	10	0.1%
0.1	5	0.1%
0.111111	8	0.1%
0.125	4	0.1%
0.142857	5	0.1%
0.166667	296	4.4%
0.181818	14	0.2%
0.2	8	0.1%

Value	Count	Frequency (%)
1	1297	19.4%
0.916667	340	5.1%
0.909091	25	0.4%
0.9	18	0.3%
0.888889	28	0.4%
0.875	28	0.4%
0.857143	29	0.4%
0.833333	304	4.6%
0.818182	20	0.3%
0.8	17	0.3%

cash_adv_freq
Real number (ℝ)

Distinct	49
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.09656973

Minimum	0
Maximum	1.25
Zeros	4430
Zeros (%)	66.4%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.10277775
95-th percentile	0.5
Maximum	1.25
Range	1.25
Interquartile range (IQR)	0.10277775

Descriptive statistics

Standard deviation	0.18236462
Coefficient of variation (CV)	1.8884243
Kurtosis	5.5384845
Mean	0.09656973
Median Absolute Deviation (MAD)	0
Skewness	2.324503
Sum	644.31324
Variance	0.033256855
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	4430	66.4%
0.083333	537	8.0%
0.166667	383	5.7%
0.25	304	4.6%
0.333333	229	3.4%
0.416667	161	2.4%
0.5	115	1.7%
0.583333	78	1.2%
0.666667	66	1.0%
0.75	40	0.6%
Other values (39)	329	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4430	66.4%
0.083333	537	8.0%
0.090909	27	0.4%
0.1	10	0.1%
0.111111	13	0.2%
0.125	18	0.3%
0.142857	21	0.3%
0.166667	383	5.7%
0.181818	17	0.3%
0.2	14	0.2%

Value	Count	Frequency (%)
1.25	1	< 0.1%
1.166667	1	< 0.1%
1.125	1	< 0.1%
1.1	1	< 0.1%
1.090909	1	< 0.1%
1	13	0.2%
0.916667	14	0.2%
0.9	1	< 0.1%
0.888889	1	< 0.1%
0.875	4	0.1%

cash_adv_TRX
Real number (ℝ)

Distinct	57
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4016787

Minimum	0
Maximum	123
Zeros	4430
Zeros (%)	66.4%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	13
Maximum	123
Range	123
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	6.2031455
Coefficient of variation (CV)	2.5828374
Kurtosis	76.675538
Mean	2.4016787
Median Absolute Deviation (MAD)	0
Skewness	6.4188562
Sum	16024
Variance	38.479014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4430	66.4%
1	446	6.7%
2	302	4.5%
3	212	3.2%
4	197	3.0%
5	155	2.3%
6	138	2.1%
7	107	1.6%
8	88	1.3%
10	87	1.3%
Other values (47)	510	7.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4430	66.4%
1	446	6.7%
2	302	4.5%
3	212	3.2%
4	197	3.0%
5	155	2.3%
6	138	2.1%
7	107	1.6%
8	88	1.3%
9	52	0.8%

Value	Count	Frequency (%)
123	2	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
71	1	< 0.1%
62	1	< 0.1%
61	1	< 0.1%
52	2	< 0.1%
51	1	< 0.1%
50	1	< 0.1%
49	1	< 0.1%

purchases_trx
Real number (ℝ)

Distinct	173
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.458483

Minimum	0
Maximum	358
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	12
Q3	23
95-th percentile	67.45
Maximum	358
Range	358
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	27.103616
Coefficient of variation (CV)	1.3928946
Kurtosis	29.636294
Mean	19.458483
Median Absolute Deviation (MAD)	8
Skewness	4.3084812
Sum	129827
Variance	734.60598
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	606	9.1%
12	537	8.0%
2	345	5.2%
6	340	5.1%
3	294	4.4%
4	277	4.2%
7	265	4.0%
8	263	3.9%
5	254	3.8%
9	240	3.6%
Other values (163)	3251	48.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	606	9.1%
2	345	5.2%
3	294	4.4%
4	277	4.2%
5	254	3.8%
6	340	5.1%
7	265	4.0%
8	263	3.9%
9	240	3.6%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%
298	1	< 0.1%
274	1	< 0.1%
273	1	< 0.1%
254	1	< 0.1%
248	2	< 0.1%

credit_limit
Real number (ℝ)

Distinct	194
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4659.5116

Minimum	150
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	150
5-th percentile	1000
Q1	1700
median	3500
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29850
Interquartile range (IQR)	4800

Descriptive statistics

Standard deviation	3752.3247
Coefficient of variation (CV)	0.80530428
Kurtosis	2.8045592
Mean	4659.5116
Median Absolute Deviation (MAD)	2000
Skewness	1.5029109
Sum	31088261
Variance	14079940
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	542	8.1%
3000	517	7.7%
1500	506	7.6%
2500	450	6.7%
4000	397	6.0%
1200	374	5.6%
6000	351	5.3%
5000	301	4.5%
2000	285	4.3%
7500	227	3.4%
Other values (184)	2722	40.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
150	1	< 0.1%
200	2	< 0.1%
300	11	0.2%
400	3	< 0.1%
450	6	0.1%
500	62	0.9%
600	17	0.3%
650	1	< 0.1%
700	13	0.2%
750	1	< 0.1%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%
22000	1	< 0.1%
21500	2	< 0.1%
21000	2	< 0.1%
20500	1	< 0.1%
20000	10	0.1%

payments
Real number (ℝ)

Distinct	6672
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1805.1465

Minimum	0.056466
Maximum	50721.483
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0.056466
5-th percentile	139.29313
Q1	426.02855
median	933.47316
Q3	2007.3252
95-th percentile	6084.4896
Maximum	50721.483
Range	50721.427
Interquartile range (IQR)	1581.2967

Descriptive statistics

Standard deviation	2955.1548
Coefficient of variation (CV)	1.637072
Kurtosis	58.778657
Mean	1805.1465
Median Absolute Deviation (MAD)	625.35113
Skewness	6.1415939
Sum	12043938
Variance	8732940.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201.802084	1	< 0.1%
2609.18811	1	< 0.1%
454.888506	1	< 0.1%
1903.279643	1	< 0.1%
2571.573214	1	< 0.1%
826.036748	1	< 0.1%
846.787917	1	< 0.1%
221.798291	1	< 0.1%
904.68554	1	< 0.1%
162.949236	1	< 0.1%
Other values (6662)	6662	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.056466	1	< 0.1%
4.523555	1	< 0.1%
4.841543	1	< 0.1%
9.533313	1	< 0.1%
14.500688	1	< 0.1%
16.385421	1	< 0.1%
18.125527	1	< 0.1%
18.208604	1	< 0.1%
18.336805	1	< 0.1%
18.496532	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%
36066.75068	1	< 0.1%
35843.62593	1	< 0.1%
33994.72785	1	< 0.1%
32048.6122	1	< 0.1%
31698.41902	1	< 0.1%

min_pay
Real number (ℝ)

Distinct	6672
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	822.0632

Minimum	0.019163
Maximum	76406.208
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0.019163
5-th percentile	71.655291
Q1	162.10854
median	246.77096
Q3	762.17827
95-th percentile	2791.5059
Maximum	76406.208
Range	76406.188
Interquartile range (IQR)	600.06973

Descriptive statistics

Standard deviation	2293.3004
Coefficient of variation (CV)	2.7896887
Kurtosis	307.26847
Mean	822.0632
Median Absolute Deviation (MAD)	146.95129
Skewness	13.807336
Sum	5484805.7
Variance	5259226.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
139.509787	1	< 0.1%
189.423175	1	< 0.1%
127.731899	1	< 0.1%
174.499877	1	< 0.1%
73.948578	1	< 0.1%
350.661181	1	< 0.1%
150.804339	1	< 0.1%
179.182583	1	< 0.1%
250.871811	1	< 0.1%
184.464721	1	< 0.1%
Other values (6662)	6662	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.261984	1	< 0.1%
0.319475	1	< 0.1%
1.113027	1	< 0.1%
2.167809	1	< 0.1%
2.891346	1	< 0.1%
3.19794	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
38512.12477	1	< 0.1%
31871.36379	1	< 0.1%
30528.4324	1	< 0.1%
29019.80288	1	< 0.1%
28483.25483	1	< 0.1%
26873.51595	1	< 0.1%
26378.90782	1	< 0.1%

prc_full_pay
Real number (ℝ)

Distinct	47
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.19266806

Minimum	0
Maximum	1
Zeros	4022
Zeros (%)	60.3%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.25
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.25

Descriptive statistics

Standard deviation	0.3207963
Coefficient of variation (CV)	1.6650206
Kurtosis	0.97538122
Mean	0.19266806
Median Absolute Deviation (MAD)	0
Skewness	1.5609776
Sum	1285.4813
Variance	0.10291027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4022	60.3%
1	462	6.9%
0.083333	331	5.0%
0.5	135	2.0%
0.166667	129	1.9%
0.25	128	1.9%
0.333333	118	1.8%
0.090909	105	1.6%
0.666667	78	1.2%
0.916667	77	1.2%
Other values (37)	1087	16.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4022	60.3%
0.083333	331	5.0%
0.090909	105	1.6%
0.1	70	1.0%
0.111111	48	0.7%
0.125	30	0.4%
0.142857	35	0.5%
0.166667	129	1.9%
0.181818	64	1.0%
0.2	69	1.0%

Value	Count	Frequency (%)
1	462	6.9%
0.916667	77	1.2%
0.909091	19	0.3%
0.9	16	0.2%
0.888889	12	0.2%
0.875	18	0.3%
0.857143	12	0.2%
0.833333	62	0.9%
0.818182	17	0.3%
0.8	33	0.5%

tenure
Real number (ℝ)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.586031

Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.2458667
Coefficient of variation (CV)	0.10753179
Kurtosis	9.6961588
Mean	11.586031
Median Absolute Deviation (MAD)	0
Skewness	-3.2414114
Sum	77302
Variance	1.5521838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
12	5792	86.8%
11	235	3.5%
10	157	2.4%
8	127	1.9%
6	126	1.9%
7	122	1.8%
9	113	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	126	1.9%
7	122	1.8%
8	127	1.9%
9	113	1.7%
10	157	2.4%
11	235	3.5%
12	5792	86.8%

Value	Count	Frequency (%)
12	5792	86.8%
11	235	3.5%
10	157	2.4%
9	113	1.7%
8	127	1.9%
7	122	1.8%
6	126	1.9%

unit_price
Real number (ℝ)

Distinct	6025
Distinct (%)	90.3%
Missing	0
Missing (%)	0.0%
Infinite	3
Infinite (%)	< 0.1%
Mean	inf

Minimum	0
Maximum	inf
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.003696115
Q1	0.010572824
median	0.018010402
Q3	0.030105673
95-th percentile	0.06555368
Maximum	inf
Range	inf
Interquartile range (IQR)	0.01953285

Descriptive statistics

Standard deviation	nan
Coefficient of variation (CV)	nan
Kurtosis	nan
Mean	inf
Median Absolute Deviation (MAD)	0.0088803843
Skewness	nan
Sum	inf
Variance	nan
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	26	0.4%
0.02190580504	25	0.4%
0.01666666667	19	0.3%
0.025	15	0.2%
0.04	15	0.2%
0.01	14	0.2%
0.05	11	0.2%
0.01111111111	11	0.2%
0.02857142857	10	0.1%
0.005	10	0.1%
Other values (6015)	6516	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
0.0001671774868	1	< 0.1%
0.0003846153846	1	< 0.1%
0.0003962847512	1	< 0.1%
0.0005	2	< 0.1%
0.0005333333333	1	< 0.1%
0.0005361803797	1	< 0.1%
0.0005524861878	1	< 0.1%
0.0005851375073	1	< 0.1%
0.0006283380459	1	< 0.1%

Value	Count	Frequency (%)
inf	3	< 0.1%
100	3	< 0.1%
20	1	< 0.1%
1.428571429	3	< 0.1%
1	3	< 0.1%
0.6756756757	1	< 0.1%
0.5	1	< 0.1%
0.3592814371	1	< 0.1%
0.350140056	1	< 0.1%
0.2732240437	1	< 0.1%

gross_revenue
Real number (ℝ)

Distinct	6265
Distinct (%)	93.9%
Missing	0
Missing (%)	0.0%
Infinite	3
Infinite (%)	< 0.1%
Mean	inf

Minimum	0
Maximum	inf
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	104.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.008034411
Q1	0.070168055
median	0.21758425
Q3	0.51634428
95-th percentile	1.8722218
Maximum	inf
Range	inf
Interquartile range (IQR)	0.44617623

Descriptive statistics

Standard deviation	nan
Coefficient of variation (CV)	nan
Kurtosis	nan
Mean	inf
Median Absolute Deviation (MAD)	0.17794016
Skewness	nan
Sum	inf
Variance	nan
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02190580504	25	0.4%
0.02	12	0.2%
0.2	10	0.1%
0.01666666667	9	0.1%
0.12	8	0.1%
0.05	7	0.1%
0.03333333333	7	0.1%
0.01	7	0.1%
0.005	6	0.1%
0.25	6	0.1%
Other values (6255)	6575	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
0.0003846153846	1	< 0.1%
0.0005	2	< 0.1%
0.0005015324603	1	< 0.1%
0.0005524861878	1	< 0.1%
0.0005851375073	1	< 0.1%
0.0006666666667	1	< 0.1%
0.0006711409396	1	< 0.1%
0.0006896551724	2	< 0.1%
0.0006928422467	1	< 0.1%

Value	Count	Frequency (%)
inf	3	< 0.1%
100	3	< 0.1%
34.34295741	1	< 0.1%
29.13183922	1	< 0.1%
25.78673544	1	< 0.1%
21.55746674	1	< 0.1%
20	1	< 0.1%
19.33165961	1	< 0.1%
17.77398204	1	< 0.1%
17.14285714	3	< 0.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	balance	balance_freq	purchases	one_purchases	install_purchases	purchases_freq	one_purchases_freq	purchases_install_freq	purchases_trx	credit_limit	payments	min_pay	prc_full_pay	tenure	unit_price	gross_revenue
0	10001	40.900749	0.818182	95.40	0.00	95.40	0.166667	0.000000	0.083333	2	1000.0	201.802084	139.509787	0.0	12	0.020964	0.041929
2	10003	2495.148862	1.000000	773.17	773.17	0.00	1.000000	1.000000	0.000000	12	7500.0	622.066742	627.284787	0.0	12	0.015521	0.186246
4	10005	817.714335	1.000000	16.00	16.00	0.00	0.083333	0.083333	0.000000	1	1200.0	678.334763	244.791237	0.0	12	0.062500	0.062500
5	10006	1809.828751	1.000000	1333.28	0.00	1333.28	0.666667	0.000000	0.583333	8	1800.0	1400.057770	2407.246035	0.0	12	0.006000	0.048002
6	10007	627.260806	1.000000	7091.01	6402.63	688.38	1.000000	1.000000	1.000000	64	13500.0	6354.314328	198.065894	1.0	12	0.009026	0.577633
7	10008	1823.652743	1.000000	436.20	0.00	436.20	1.000000	0.000000	1.000000	12	2300.0	679.065082	532.033990	0.0	12	0.027510	0.330124
8	10009	1014.926473	1.000000	861.49	661.49	200.00	0.333333	0.083333	0.250000	5	7000.0	688.278568	311.963409	0.0	12	0.005804	0.029019
9	10010	152.225975	0.545455	1281.60	1281.60	0.00	0.166667	0.166667	0.000000	3	11000.0	1164.770591	100.302262	0.0	12	0.002341	0.007022
10	10011	1293.124939	1.000000	920.12	0.00	920.12	1.000000	0.000000	1.000000	12	1200.0	1083.301007	2172.697765	0.0	12	0.013042	0.156501
11	10012	630.794744	0.818182	1492.18	1492.18	0.00	0.250000	0.250000	0.000000	6	2000.0	705.618627	155.549069	0.0	12	0.004021	0.024126

	id	balance	balance_freq	purchases	one_purchases	install_purchases	cash_adv	purchases_freq	one_purchases_freq	purchases_install_freq	cash_adv_freq	cash_adv_TRX	purchases_trx	credit_limit	payments	min_pay	prc_full_pay	tenure	unit_price	gross_revenue
8934	19175	20.260716	0.833333	110.50	0.00	110.50	0.000000	0.666667	0.000000	0.500000	0.000000	0	4	1500.0	161.476789	65.936751	0.50	6	0.036199	0.144796
8936	19177	108.977282	1.000000	712.50	0.00	712.50	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	605.716356	86.868595	0.75	6	0.008421	0.050526
8939	19180	728.352548	1.000000	734.40	734.40	0.00	239.891038	0.333333	0.333333	0.000000	0.166667	2	2	1000.0	72.530037	110.950798	0.00	6	0.002723	0.005447
8940	19181	130.838554	1.000000	591.24	0.00	591.24	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	475.523262	82.771320	1.00	6	0.010148	0.060889
8941	19182	5967.475270	0.833333	214.55	0.00	214.55	8555.409326	0.833333	0.000000	0.666667	0.666667	13	5	9000.0	966.202912	861.949906	0.00	6	0.023305	0.116523
8942	19183	40.829749	1.000000	113.28	0.00	113.28	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	94.488828	86.283101	0.25	6	0.052966	0.317797
8943	19184	5.871712	0.500000	20.90	20.90	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	1	500.0	58.644883	43.473717	0.00	6	0.047847	0.047847
8945	19186	28.493517	1.000000	291.12	0.00	291.12	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	325.594462	48.886365	0.50	6	0.020610	0.123660
8947	19188	23.398673	0.833333	144.40	0.00	144.40	0.000000	0.833333	0.000000	0.666667	0.000000	0	5	1000.0	81.270775	82.418369	0.25	6	0.034626	0.173130
8949	19190	372.708075	0.666667	1093.25	1093.25	0.00	127.040008	0.666667	0.666667	0.000000	0.333333	2	23	1200.0	63.165404	88.288956	0.00	6	0.021038	0.483878

Overview

Variables

Interactions

Missing values

Sample